package com.yunupmall.mapper.FordMapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.yunupmall.api.fordentity.ExpandOrder;
import com.yunupmall.api.po.OrderbyidCommtityPo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ExpandOrderMapper extends BaseMapper<ExpandOrder> {

    @Select("select com.example_image1 as image,com.name,spe.c_sku as sku,spe.prices as price,ex.count as count from expand_order ex left join commodity com  on ex.c_id=com.id left join specs_commodity spe on ex.specs_id=spe.id where ex.order_id=#{id}")
    List<OrderbyidCommtityPo> getCommtitySpecec(@Param("id") Integer id);
}
